package com.sdy.dao.mysql;

import com.sdy.po.OverView;
import com.sdy.po.Parm;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

@Mapper
public interface ParmMapper {

    @Select("select * from s_manage_overview_data where updatetime>=#{startDate} and updatetime<=#{finishDate}")
    List<OverView> selectOverViewByDate(@Param("startDate") Date startDate, @Param("finishDate") Date finishDate);

    @Select("select * from po_parm")
    List<Parm> selectAllParm();

    @Select("select * from po_parm where id = #{id}")
    Parm selectById(@Param("id") Integer id);

//    @Select("select updatetime from s_manage_overview where updatetime>=#{startDate} and updatetime<=#{finishDate}")
//    List<OverView> selectUpdateTimeByDate(@Param("startDate") Date startDate, @Param("finishDate")Date finishDate);
//
//    @Select("select activeuser from s_manage_overview where updatetime>=#{startDate} and updatetime<=#{finishDate}")
//    List<OverView> selectActiveUserByDate(@Param("startDate") Date startDate, @Param("finishDate")Date finishDate);
//
//    @Select("select registuser from s_manage_overview where updatetime>=#{startDate} and updatetime<=#{finishDate}")
//    List<OverView> selectRegistUserByDate(@Param("startDate") Date startDate, @Param("finishDate")Date finishDate);
//
//    @Select("select onlineuser from s_manage_overview where updatetime>=#{startDate} and updatetime<=#{finishDate}")
//    List<OverView> selectOnlineUserByDate(@Param("startDate") Date startDate, @Param("finishDate")Date finishDate);
}
